from django.db import models
from organization.models import CourseOrg,Teacher
from DjangoUeditor.models import UEditorField

from datetime import datetime
# Create your models here.

class Course(models.Model):
    course_org=models.ForeignKey(CourseOrg,verbose_name=u"课程机构",null=True,blank=True,on_delete=models.CASCADE)
    teacher=models.ForeignKey(Teacher,verbose_name=u"课程讲师",null=True,blank=True,on_delete=models.CASCADE)
    name=models.CharField(max_length=50,verbose_name=u"课程名称")
    desc=models.CharField(max_length=300,verbose_name=u"课程描述")
    #detail=models.TextField(verbose_name=u"课程详情")
    detail=UEditorField(verbose_name=u"课程详情",width=600,height=300,imagePath="course/ueditor/",filePath="course/ueditor/",default="")
    is_banner=models.BooleanField(default=False,verbose_name=u"是否轮播")
    degree=models.CharField(max_length=2,verbose_name=u"学习难度",choices=(('cj','初级'),('zj','中级'),('gj','高级')))
    learn_times=models.IntegerField(default=0,verbose_name=u"学习时长（分钟数）")
    students=models.IntegerField(default=0,verbose_name=u"学习人数")
    fav_nums=models.IntegerField(default=0,verbose_name=u"收藏人数")
    image=models.ImageField(upload_to="courses/%Y/%m",verbose_name=u"封面图",max_length=100)
    click_num=models.IntegerField(default=0,verbose_name=u"点击数")
    category=models.CharField(default='后端开发',max_length=20,verbose_name=u"课程类别")
    youneed_know=models.CharField(default='',max_length=200,verbose_name=u"课程须知")
    teacher_tell=models.CharField(default='',max_length=200,verbose_name=u"你能学到什么")
    tag=models.CharField(default='',max_length=10,verbose_name=u"课程标签")
    add_time=models.DateTimeField(default=datetime.now,verbose_name=u"添加时间")

    class Meta:
        verbose_name=u"课程"
        verbose_name_plural=verbose_name

    #获取章节数量
    def get_zj_nums(self):
        return self.lesson_set.all().count()

    get_zj_nums.short_description="章节总数"

    #获取课程的学习用户
    def get_learn_users(self):
        return self.usercourse_set.all()[:2]

    #获取课程所有章节
    def get_course_lesson(self):
        return self.lesson_set.all()

    def __str__(self):
        return self.name


class Lesson(models.Model):
    course=models.ForeignKey(Course,verbose_name=u"课程",on_delete=models.CASCADE)
    name=models.CharField(max_length=100,verbose_name=u"章节名")
    add_time=models.DateTimeField(default=datetime.now,verbose_name=u"添加时间")

    class Meta:
        verbose_name=u"章节"
        verbose_name_plural=verbose_name

    # 获取章节所有视频
    def get_lesson_video(self):
        return self.video_set.all()

    def __str__(self):
        return self.name


class Video(models.Model):
    lesson=models.ForeignKey(Lesson,verbose_name=u"章节",on_delete=models.CASCADE)
    name=models.CharField(max_length=100,verbose_name=u"视频名")
    learn_times=models.IntegerField(default=0,verbose_name=u"学习时长（分钟数）")
    url=models.CharField(max_length=100,default="",verbose_name=u"访问地址")
    add_time=models.DateTimeField(default=datetime.now,verbose_name=u"添加时间")

    class Meta:
        verbose_name=u"视频"
        verbose_name_plural=verbose_name

    def __str__(self):
        return self.name


class CourseResource(models.Model):
    course=models.ForeignKey(Course,verbose_name=u"课程",on_delete=models.CASCADE)
    name=models.CharField(max_length=100,verbose_name=u"名称")
    download=models.FileField(upload_to="course/resource/%Y/%m",verbose_name=u"资源文件",max_length=100)
    add_time=models.DateTimeField(default=datetime.now,verbose_name=u"添加时间")

    class Meta:
        verbose_name=u"课程资源"
        verbose_name_plural=verbose_name

    def __str__(self):
        return self.name